UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZloHc2JJn7DZS+x2ac65d2jpU2IEJGbaxno/nqma8rU='
WHERE
key_id = '148199a898b12202ce42108924c07027e9c047b0dc0b7062d26aa3b6d730122a'
AND (
token = 'ZloHc2JJn7DZS+x2ac65d2jpU2IEJGbaxno/nqma8rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)