UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imEI3TgB5qtrG0rR40OZvYcPkjX4HED2V4e9NAEqXjw='
WHERE
key_id = '1bd793bea2f3d964bd54bb08d1e851d838922434352943a0de52e2881d544bbc'
AND (
token = 'imEI3TgB5qtrG0rR40OZvYcPkjX4HED2V4e9NAEqXjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)