UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ui7s3N9YrgY5pfGhgl61KYlN2RroybqfeoNudBtdiw='
WHERE
key_id = '836050998fbade287d8123e398a324455335f2c8f7d0720d01c7f726a37fdcde'
AND (
token = '/ui7s3N9YrgY5pfGhgl61KYlN2RroybqfeoNudBtdiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)