UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KkNaDZCrATG/o6Yke7k7Xxz95ZGd4u4tqbv3DNnqRLA='
WHERE
key_id = 'ea533008598758e1ebac48af7d6b2b763bfc63c127353bb7021b2ee5d672ae2b'
AND (
token = 'KkNaDZCrATG/o6Yke7k7Xxz95ZGd4u4tqbv3DNnqRLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)