UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0I7oh5SvVgbj8mhJOz5pv9lgU9qzArp5ruW1GHuDhM='
WHERE
key_id = '997a4697608c61a93573775d651b76d69cef9e54d17d0236e9c2e6c4e59b5cce'
AND (
token = 'U0I7oh5SvVgbj8mhJOz5pv9lgU9qzArp5ruW1GHuDhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)