UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cDYqcT00sPpAB64ojxwOelUGs39TgBJVYx1Bes7U6Ys='
WHERE
key_id = 'd0612ba2614c78a5d97a7fbc73ae95d7789a80929324328e4c9d2b2d9be62a9f'
AND (
token = 'cDYqcT00sPpAB64ojxwOelUGs39TgBJVYx1Bes7U6Ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)