UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9uct6Tmi31ApZuw6G821Lksqbfhn34xG8yxCqVFIAgA='
WHERE
key_id = '7981d4f08f35e7ec73fafde9ea814aeff913ad3914333aa224dfaa75093a014a'
AND (
token = '9uct6Tmi31ApZuw6G821Lksqbfhn34xG8yxCqVFIAgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)