UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iFMKyzCYkQkkHd9392/5ruPPMsjZKPxfcved09L0L4E='
WHERE
key_id = '6385e2c8eeae88c18ef9b2553732df3eee68a97799b4bfea54285d1c0d4d0050'
AND (
token = 'iFMKyzCYkQkkHd9392/5ruPPMsjZKPxfcved09L0L4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)