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