UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzZCbY5JEK4DoM3GjfzujUoqbOiWYsNGc+AmvaaT9sc='
WHERE
key_id = 'ed4e3147e973ea7f56b25b2359ac29bf64bcf0014b5d2973a5b1d5cb1aa6cda0'
AND (
token = 'kzZCbY5JEK4DoM3GjfzujUoqbOiWYsNGc+AmvaaT9sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)