UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1VSE3+bjxMw9LsazrIV1iQkkoVA0w4yvbbwKw26Ehc='
WHERE
key_id = '8172dcbbf8c1b3efb1f9a1b278315c4aaa3fae0e02c5d2ba31d0845b4397f2bc'
AND (
token = 'N1VSE3+bjxMw9LsazrIV1iQkkoVA0w4yvbbwKw26Ehc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)