UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hafZbn+6CxE+9QoRmhrA/S7tFqJgEUp2IFiXp1Z35wQ='
WHERE
key_id = '4781cf3eab6c46ee9f09fdf5e0c7d9f625304c3ad962da7e9d930e52d558d5d1'
AND (
token = 'hafZbn+6CxE+9QoRmhrA/S7tFqJgEUp2IFiXp1Z35wQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)