UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LE5lX0VOm9pQQlSUQJmxPhpSzxMmh+V1aIFi38ph448='
WHERE
key_id = 'c138143d03da03c5d03ff40a03fe704171511a8c8604ede1bce60d93d267ec84'
AND (
token = 'LE5lX0VOm9pQQlSUQJmxPhpSzxMmh+V1aIFi38ph448='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)