UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6dirsuosG2NNH8xO3GrzdW0I1LTktkbQHzQth/FnoXw='
WHERE
key_id = 'bb64a343b8d5108906a81d2c2f18ddf3f90a56e6f232062701aebacb7065c055'
AND (
token = '6dirsuosG2NNH8xO3GrzdW0I1LTktkbQHzQth/FnoXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)