UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M8R7K7dKGZXAqL9T/4uFe9FFgoq8S+pbeBqI7oZrf4U='
WHERE
key_id = 'a6cd409ecf0560a0295d9c2a9054c19859690d7b1a84badd09d180179a622ca1'
AND (
token = 'M8R7K7dKGZXAqL9T/4uFe9FFgoq8S+pbeBqI7oZrf4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)