UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dJnZFXcT1W7wTJ6X2xDeUXr34/J1R3kM7znBKc8P3KI='
WHERE
key_id = 'a453f72a9de34ba212dc72244c5e330d548c41f941b550afc2d41a5f9377e24a'
AND (
token = 'dJnZFXcT1W7wTJ6X2xDeUXr34/J1R3kM7znBKc8P3KI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)