UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vLO9pPjrMG3/Xe9FjKD8qGFBltEQd1n9d8FA5S5mFYQ='
WHERE
key_id = '9b299462f813aabb6e7cbba466a4ac3891d8c8a175d15c9e11f95babbde96996'
AND (
token = 'vLO9pPjrMG3/Xe9FjKD8qGFBltEQd1n9d8FA5S5mFYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)