UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVGmIeNQn1ecKDW5LYbLHd5XBwPBuY/wrAlenwKuRP8='
WHERE
key_id = '56007f4b18449c21656ae644be44d4646f61ab8184824da1fcf294d2ad9d9395'
AND (
token = 'RVGmIeNQn1ecKDW5LYbLHd5XBwPBuY/wrAlenwKuRP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)