UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWoRdNu6Xf4iNPLny8iNK5NWD61ST08IoDYWivILaDo='
WHERE
key_id = '4cf6944a9655dcaf025dc76594463c92ec19e0004f7efb8952200edb06a867ef'
AND (
token = 'zWoRdNu6Xf4iNPLny8iNK5NWD61ST08IoDYWivILaDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)