UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9h2HcHRthBATBgIc/KAjtiM6jn9Gf3p6FoRrHzvCyWI='
WHERE
key_id = 'e1e3010af65032494783cdac87b7e59a667b951690d54fe08602bf0a9193e336'
AND (
token = '9h2HcHRthBATBgIc/KAjtiM6jn9Gf3p6FoRrHzvCyWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)