UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7bpp1DpPuF8AiB3Nds1DfnLJNl13vN102u0KayT5MHM='
WHERE
key_id = '1f8d2112a8708b6c73ceb86ccc8cd593dbaf11b221e22c4fa5ba076600a01ad5'
AND (
token = '7bpp1DpPuF8AiB3Nds1DfnLJNl13vN102u0KayT5MHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)