UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LiCaOwnMkwpibdcHmnqWNIOFTBrIK1J6zdlts8RFq4M='
WHERE
key_id = 'd2048cd7bcd72319a5f8662bd56d2855545363dec6e1251e75ac40117a9c6c77'
AND (
token = 'LiCaOwnMkwpibdcHmnqWNIOFTBrIK1J6zdlts8RFq4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)