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