UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L8W9ni237nS81yqmc5g7jmlPHFP2aY3E9E0ZQqGZPTM='
WHERE
key_id = '0eef5e5c6c676065ce555ce45bc89c71ee08c0ed7b290a71bd6efbd853a7bd4e'
AND (
token = 'L8W9ni237nS81yqmc5g7jmlPHFP2aY3E9E0ZQqGZPTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)