UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BoT7bN86+NgANbMxe7WWX4q8j5KZy+Ykz2mEZj9haEc='
WHERE
key_id = '773eb9e854c720c5465ca4afdab7fc4fcd5b5d7163dd875a8de4948697479a91'
AND (
token = 'BoT7bN86+NgANbMxe7WWX4q8j5KZy+Ykz2mEZj9haEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)