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