UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRgB5C89uvCeoTrAwUdhI5XozI1hKJqp+B4RYhyodjU='
WHERE
key_id = '3a0222a0a3db49df81cdaadf199d4b07e2d16cedfc34a1f3b58790f7ed807457'
AND (
token = 'KRgB5C89uvCeoTrAwUdhI5XozI1hKJqp+B4RYhyodjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)