UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z9NYwQMU7302yFuFrpxIkTXiq2LjX4LCJUgddCrGKeI='
WHERE
key_id = '7de27354e22c8b3c93c04bc7661b5c39473e67f0b7e165ad73df7301e7e26d58'
AND (
token = 'Z9NYwQMU7302yFuFrpxIkTXiq2LjX4LCJUgddCrGKeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)