UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8upPaYl6kPTVta3fokHzZXfCcNxAS7n3xPTPrlfHgnk='
WHERE
key_id = 'e3d7482360feec8da99e8aa08e1322e198b3436018ffd4b2d8887873eb60b813'
AND (
token = '8upPaYl6kPTVta3fokHzZXfCcNxAS7n3xPTPrlfHgnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)