UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6uVfk6hSDhKMtQ9sXmF5cKvhLYVA9b7+9gT2aKbBsto='
WHERE
key_id = 'deedbb4f512bda4347ac269a8a7c380191863442cc19737b450f677a190df10d'
AND (
token = '6uVfk6hSDhKMtQ9sXmF5cKvhLYVA9b7+9gT2aKbBsto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)