UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnJlSSS7JPRb+ST6/ui1e5Hpbsk8BRFAdhZXINzdNLw='
WHERE
key_id = '832e899ee69163c9a10d7c76674ba887392bfb968d6e559c2cebe75f0274782c'
AND (
token = 'ZnJlSSS7JPRb+ST6/ui1e5Hpbsk8BRFAdhZXINzdNLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)