UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6P5KoPyEyxRmzQVkIFIinSKZTsZu9WzAuLmHl6yTNk='
WHERE
key_id = '9450c5f97f0cfe88ae7de6ae4267b54af1a99b81c58ed2467ffffc4a0b0d399c'
AND (
token = 'a6P5KoPyEyxRmzQVkIFIinSKZTsZu9WzAuLmHl6yTNk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)