UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qij8pv2fCXBXaDDSWb2QEXUb8Q0bSz25JheC1d5ukzg='
WHERE
key_id = 'cd06a8d6b881ff9ce69c53efb7b2aabc6565e91aa8a4df8c2859dc31ebf5809a'
AND (
token = 'Qij8pv2fCXBXaDDSWb2QEXUb8Q0bSz25JheC1d5ukzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)