UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'klLBCbXPhzOylQoVc4BJHYolX9k2HWXuDTRv9NwIero='
WHERE
key_id = '46c3f8da4d72c8da6c0dceb19fa8b0d3d64cefcd0cdf739a3aa336f80a492bf2'
AND (
token = 'klLBCbXPhzOylQoVc4BJHYolX9k2HWXuDTRv9NwIero='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)