UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6KkAh5kCYf7OkjKCot4e4rWL5gA/wfrTXfOjo2Ckzk='
WHERE
key_id = 'a1fc5d0794e5d89ce70441566ab95edfb756c4c7685297086731ad18f0ab30db'
AND (
token = 'Z6KkAh5kCYf7OkjKCot4e4rWL5gA/wfrTXfOjo2Ckzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)